
drop table if exists jms_dm.dm_first_center_arrival_statistics_dt;
create external table if not exists jms_dm.dm_first_center_arrival_statistics_dt(
        scan_site_code       string comment '扫描站点code'
       ,scan_site_name       string comment '扫描站点名称'
       ,scan_date            string comment '扫描日期'
       ,pick_network_code    string comment '揽收网点code'
       ,pick_network_name    string comment '揽收网点名称'
       ,scan_cnt             string comment '扫描数量'
) comment '首中心到件统计'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_first_center_arrival_statistics_dt'
tblproperties (
    'discover.partitions'='false',
    'parquet.column.index.access'='true'
);
